home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / prorphans.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  35 lines
  1. /* RCSVER $Id: prorphans.sql,v 1.2 1999-12-02 16:58:34-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        prorphans.sql
  6. * Date:        08/18/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the prorphans table.  This table contains
  9. *        closed unmatched probed data counts.     
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE prorphans
  13. (
  14.     prpend_indx        NUMBER(38),    /* index for this probe */
  15.     farebox_glid        NUMBER(38),    /* farebox number */
  16.     cashbox_glid        NUMBER(38),    /* cashbox number */
  17.     cb_sernum        VARCHAR2(20),    /* cashbox ID */
  18.     cbinsert_seq        NUMBER(38),    /* number from cbinsert table */
  19.     cbremov_seq         NUMBER(38),    /* number from cbremov table */
  20.     cbinsert_date        DATE,        /* date of cashbox insert */
  21.     cbremov_date        DATE,        /* date of cashbox removal */
  22.     probe_date        DATE,
  23.     last_curstate        NUMBER(38),    /* last curstate prior to removal */
  24.     revenue_service_seq    NUMBER(38),    /* revenue sequence number from curstate */
  25.     probe_coin_totals    NUMBER(36,2),
  26.     probe_bill_totals    NUMBER(36,2),
  27.     probe_amt        NUMBER(36,2),    /* amount in cashbox */
  28.     clbatch_seq        NUMBER(38),    /* Close batch number */
  29.     conversion_num        NUMBER(38),    /* probe convert number */
  30.     comments        VARCHAR2(500),    /* User comments */
  31.     excp_num        NUMBER(38),    /* Exception number */
  32.     revenue_service_time    DATE,        /* Cashbox insert time */
  33.     CONSTRAINT pk_prorphans PRIMARY KEY (prpend_indx)
  34. );
  35.